Essay on Graphical User Interface and Format Cells Dialog

Submitted By lanmerd
Words: 2521
Pages: 11
Open Document
Excel Chapter 3
Multiple Choice
Identify the choice that best completes the statement or answers the question.
____ 1.
By default, all columns in a worksheet
a.
expand automatically to accommodate longer values.
b.
are different widths.
c.
are hidden.
d.
are the same width.
____ 2.
You can adjust a column width to fit the longest entry in the column by positioning the mouse pointer on the right column boundary and
a.
double-clicking the right mouse button.
b.
double-clicking the left mouse button.
c.
clicking the right mouse button.
d.
clicking the left mouse button.
____ 3.
The column width number in the Column Width dialog box represents
a.
the width of the column measured in inches.
b.
the average number of characters in the standard font that will fit in a cell.
c.
the width of the column measured in the typesetting unit called picas.
d.
the width of the column measured in millimeters.
____ 4.
To increase the width of a column using your mouse, position the mouse pointer on the right boundary line in the column header until the mouse pointer turns into a __________, then drag the boundary to the right.
a.
plus sign (+).
b.
hand.
c.
double-headed arrow pointing up and down.
d.
double-headed arrow pointing left and right.
____ 5.
Which of the following is the correct sequence of steps for displaying the Column Width dialog box?
a.
Click the Format button in the Cells group on the Home tab, click Format Cells, and then click Column Width.
b.
Click the Format button in the Cells group on the Home tab, click Format Cells, and then click Alignment.
c.
Click the Format button in the Cells group on the Home tab and then click Column
Width.
d.
Click the Format button in the Cells group on the Home tab and then click AutoFit
Column Width.
____ 6.
In this illustration, the user is
a.
moving data from one cell to another.
b.
changing a row height.
c.
changing a column width.
d.
using the AutoFill feature.
____ 7.
To insert a new row in a worksheet, select __________, and then click the Insert button.
a.
the row above where the row is to be inserted
b.
the row below where the row is to be inserted
c.
the first row of the worksheet

d. the last row of the worksheet
____ 8.
Which of the following is the correct sequence of steps for changing a row height using the Row Height dialog box?
a.
In the Cells group on the Home tab click the Format button and then click Row Height.
b.
In the Cells group on the Home tab click the Format button and then click AutoFit Row
Height.
c.
In the Cells group on the Home tab click the Format button, click Format Cells, and then click Row Height.
d.
In the Cells group on the Home tab click the Format button, click Format Cells, and then click Line Width.
____ 9.
To change the height of a row using your mouse, position the mouse pointer on the boundary line in the row header until the mouse pointer turns into a __________, then drag the boundary to the desired height.
a.
plus sign (+)
b.
hand
c.
double-headed arrow pointing up and down
d.
double-headed arrow pointing left and right
____ 10.
You can use your mouse to change the height of multiple rows at the same time if the rows are
a.
not adjacent to one another.
b.
all the same height to begin with.
c.
not selected.
d.
adjacent to one another.
____ 11.
When a row height is being changed, the row height number that displays represents a measurement in both pixels and
a.
points.
b.
picas.
c.
inches.
d.
millimeters.
____ 12.
By default, when inserting a column in worksheet, the new column is placed
a.
immediately to the right of the column containing the active cell.
b.
one column to the left of the last column of the worksheet that contains data.
c.
immediately to the left of the column containing the active cell.
d.
at the far left of the worksheet.
____ 13.
You can insert a new row in a worksheet by making a cell
Show More

Related Documents: Essay on Graphical User Interface and Format Cells Dialog

The Basics Of A Notes On The Computer System

command Eg. Clear = 10, this will make the previous clear command unusable Cannot start a variable with a number Commands Diary Clear - clear previous command Clc-same as clear Pathtool - pathtool opens the Set Path dialog box, a graphical user interface you use to view and modify the MATLAB® search path. Whos - display all the variable and it's size Edit- opens the gui editor Plot - place a dot on a graph Eg. Plot(5,9,'*','markersizer',100) Can set shape by writing "*"…

Words 432 - Pages 2

Computer Applications Test Essay

justification instructed to use any other is called the __________. 5) To insert the name of a document, use the __________ a) header and footer command. 6) To align text with both margins, use the __________ a) right alignment feature. 7) A collection of formats to be associated with various a) style parts of a document, such as different heading levels, are called __________. 8) To print a character below the usual text line, use the a) Superscript __________. a) setting tabs. 9) Common formatting features…

Words 2430 - Pages 10

Essay Entity Relation Diagram

Contents ERD (Entity Relation Diagram) 2 2.1 History of ERD 2 2.2 Building Blocks 2 2.2.2 Relationship 2 2.3. Diagramming Conventions 3 MS ACESS TABLE 5 3.1 Parts of Table 6 3.2 Creating Tables in Access 6 Chapter No 2 ERD (Entity Relation Diagram) 2.1 History of ERD An entity-relationship model (ERM) is an abstract and conceptual representation of data. Entity-relationship modeling is a database modeling method, used to produce a type of conceptual schema or semantic data…

Words 3556 - Pages 15

Computer crime involves Essay example

Computer crime involves:  Theft by computer (including identity theft and phis hing)  Software piracy and intellectual property misuse  Software sabotage (malw are- including worms, viruses, Trojan horses, e tc.)  Hacking and electronic trespassing. The computer crime dossier  Computer crime: any crime accomplished through knowledge or use of computer technology  Businesses and government institutions lose billions of dollars every year to computer criminals  The majority of crimes is committed…

Words 7422 - Pages 30

Managing Information Technology (7th Edition) Essay

CONTENTS: CASE STUDIES CASE STUDY 1 Midsouth Chamber of Commerce (A): The Role of the Operating Manager in Information Systems CASE STUDY I-1 IMT Custom Machine Company, Inc.: Selection of an Information Technology Platform CASE STUDY I-2 VoIP2.biz, Inc.: Deciding on the Next Steps for a VoIP Supplier CASE STUDY I-3 The VoIP Adoption at Butler University CASE STUDY I-4 Supporting Mobile Health Clinics: The Children’s Health Fund of New York City CASE STUDY I-5…

Words 239873 - Pages 960