NEW
Font size
WorksheetsMicrosoft Excel Units 1-3 Test
Total questions: 20
Worksheet time: 10mins
Which of the following options in Backstage View contains the command to change the file type of a saved file?
Export
Info
New
Publish
Which of the following groups on the Home tab contains the commands to insert, delete and format cell width and height?
Numbers
Styles
Cells
Editing
Which tab on the Ribbon contains the function library?
Home
Insert
Page Layout
Formulas
Which view should be used if you want to see where page breaks will occur in a worksheet?
Normal View
Page Break View
Page Layout View
Synchronous View
Which of the following keyboard shortcuts should be pressed to hide the columns which are selected in a worksheet?
Control H
Control 9
Control X
Control 0
Which of the following is a relative cell reference?
A1
B$1
$C1
$D$2
Which of the following is a temporary storage area where all cut and copied items are stored?
Formula Bar
Name Box
Clipboard
Workbook
Which group on the Home tab contains the command for changing the fill color of a cell?
File
Font
Alignment
Editing
Joe wants to copy the formatting of cells A1 through C1 in his workbook to use in another location. Which of the following commands should he use?
Cut Painter
Copy Painter
Paste Painter
Format Painter
Which of the following groups on the Home tab contains the command to insert a worksheet?
Cells
Font
Alignment
Number
Which of the following keys can be pressed while dragging a worksheet to another location in the workbook to copy it?
Shift
Enter
Control
Spacebar
Which of the following appears around cells which have been copied?
Stationary blue and white dotted lines
Moving red and white dotted lines
Moving green and white dotted lines
Stationary red and white dotted lines
Which of the following is NOT a method of changing the height of a row?
Dragging the bottom border of the row to a different location
Selecting the row and pressing the up arrow
Clicking the Format icon and choosing the Row Height option and changing the height
Clicking the Format icon and choosing the AutoFit Row Height option
Candace wants to change the page orientation of the printed worksheet. Which group on the Page Layout tab contains the command to complete this action?
Themes
Scale to Fit
Sheet Options
Page Setup
On a spreadsheet which of the following is a true statement?
Rows run horizontal and vertical
Columns contain numbers and Rows contain letters
Columns run vertical and Rows run horizontal
Rows run vertical and Columns run horizontal
When you click on a cell, that cell then becomes:
Angry
Active
Effective
Engaged
What is the name of the software we are currently learning about?
Microsoft Accel
Microsoft PowerPoint
Microsoft Sheets
Microsoft Excel
What is the shortcut to select an entire column in a worksheet?
Control Spacebar
Control E
Shift Spacebar
Shift E
Which of the following is an example of an absolute cell reference?
$C4
C4
$C$4
C$4
To make a non-contiguous selection, a user must:
Click a cell and drag the mouse over the other cells they wish to select
Click a cell, press the shift key, and click the cell where the selection should end
Press the control key and hit the spacebar to activate the cells
Click a cell, press the control key, and click the other cells they wish to select
