WorksheetsExcel championship - Level 1
Total questions: 25
Worksheet time: 9mins
In Excel, what is the result of = 1 + 3 * 2 / 2 - 1 ?
2
3
4
6
Which of the following shows a formula for a reference to another workbook?
=SUM(C2:E12)
=Q3Expenses!A19
=[Media.xlsx]MasterList!$D$10
=SUM(budget.summary)
Which Excel feature automatically fills cells with data from another cell or range or completes a data series?
Range Fill
Auto Fill
Data Fill
Complete Fill
Using the Delete key removes both text and formats from a cell
True
False
By default, Excel starts a new workbook with four worksheets
True
False
If you want to use a workbook in another kind of document, you have the option to save using which of the following?
File format
Worksheet
File sheet
File range
What is the name of the feature that saves copies of your files at specified intervals?
Protect Sheet
Track Changes
AutoRecover
Document Recovery
Page Layout view is useful when preparing your data for printing.
True
False
Which predesigned file already has a significant amount of formatting, text, and other features?
Blank workbook
Preset file
Text file
Template
How do you move a group of cells like this?
point to the selection's border and drag the selected cells
point to the selection's border, press Ctrl, and drag the selected cells
point to the selection's border, press Alt, and drag the selected cells
point to the selection's border, press Ctrl+Alt+Shift+F12+PgUp, and drag the selected cells
Which of the following is not an arithmetic operator?
+
-
*
]
Which feature enables you to create custom tabs and groups?
View
Tab
Ribbon
Quick Access Toolbar
What will happen when you click the button highlighted above?
the selected text will be bold, Calibri, 11 pt, yellow font
the selected text will be bold, Calibri, 12 pt, yellow font
the selected text will be bold, Calibri, 11 pt, highlighted in yellow
the selected text will be bold, Calibri, 12 pt, highlighted in yellow
You just hit the Print button. How many sheets will you find on the printer?
4
8
16
32
Ctrl + O opens a new blank workbook
True
False
What will happen when you click the button highlighted above?
the selected text will be bold, Calibri, 12 pt
the selected text will be bold, Calibri, 10 pt
the selected text will be non-bold, Calibri, 12 pt
the selected text will be bold, Comic Sans, 10 pt
In the example above, Excel's FillSeries feature extends the series when you drag the fill handle in the lower-right corner of the selection. But what is the quickest way copy the original values?
copy the original values and paste into each of the new cells
copy the original values and press the Sort button
drag the fill handle while pressing Ctrl
use the Format Painter
Dates can be displayed in only one way in Excel
True
False
If you format a number with the following Custom formatting: hh:mm:ss d-mmm-yyyy. How might the resulting date look?
01:11:31 9-Sep-20
01:11:31 9-September-2020
01:11:31 9-Sep-2020
01:11 9-Sep-2020
Use Ctrl + N to create a new workbook
True
False
What type of chart is this?
Roti
Doughnut
Pie
Radar
Which of the following is where you can save, select a template, change document properties, and close or exit Excel?
Backstage
Edit
Windows
Which of the following will return your worksheet to 100% with one click?
A
B
C
D
Which cell would you click to freeze Rows 1-5 and Column A?
A5
A6
B5
B6
Which of the following options can be used to fit the worksheet to one page?
Collated
Orientation
Margins
Scaling
