Font size
WorksheetsExcel
Total questions: 40
Worksheet time: 20mins
What does this button mean?
Align the text on the borders of the page.
Extend the content on the entire length of the cell.
Group together the selected cells and center the content.
None of the above
What type of chart is this?
Doughnut
Radar
Bar
Pie
If you copy the formula =$B38 into another cell, the result will be:
The column part will remain the same
The row part will remain the same
Both the column and row will remain the same
Both will change
What will be the formula in the C5 cell if you want to copy it the the cells just below?
=$C3/B6
=C$3/B6
=C3/$B6
=C3/B$6
What tool is used to split the window into different parts of the same worksheet?
The title bar
The scroll bar
The toolbar
The split box
What is the combination of keys required to come back to the top of the worksheet?
PageUp (PgUp)
Alt and PageUp
CTRL and Home
CTRL and left arrow
What key is used to select multiple ranges of cells?
Shift
CTRL
Alt
AltCar or AltGr
What key should be used to change the content of a cell?
F1
F2
F3
F4
This button represents:
The AutoCorrect button
The AutoFormat button
The AutoSum button
The conditional format button
What is the most appropriate formula you can put in the B2 cell to calculate a 7% tax? (Select all that apply)
=A2*0.07
=A2*7%
=A2*1.07
=A2+(A2*0.07)
What function offers you the possibility to view different results depending on the entered condition?
=If()
=Sum()
=SumIf()
=TrueFalse()
What function is used to make sure that all conditions are true before showing a TRUE answer?
=AND()
=OR()
=Vlookup()
=If()
Which of these three functions will give you TRUE as an answer?
=AND(A1=1;A2=2)
=OR(A1=2;A2=1)
=IF(A1>1);"TRUE";"FALSE")
None of the above
Which of these statements on Vlookup() is false?
The Vlookup function can be used to compare a value that's between two values or for an exact value.
When this function is used to find a value between , you must always place the smallest possible value first in the first column.
The values of the first column must be in descending order.
With this function, the comparison table is always read vertically.
What will be the result according to this formula: =vlookup(B1;A4:B8;2)?
A
B
C
D
E
What will be the result from this vlookup() function?
1%
2%
3%
5%
None of the above
What tool helps you to optimize the results of a model?
Scenario manager
Solver
Target value
None of the above
True or false: The values that I enter in the scenario manager have an impact on my model.
True
False
Which button or command doesn't copy the content of a cell or a range of cells?
The Copy option from the context menu.
The CTRL and C keys.
None of the above
What is the "Active Cell" in Excel?
The Bottom cell in a worksheet. It is indicated by a dark border onscreen.
The current cell in a worksheet. It is indicated by a dark border onscreen.
The top cell in a worksheet. It is indicated by a dark border onscreen.
The past cell in a worksheet. It is indicated by a dark border onscreen.
Define Cell?
The dark bordered box in excel.
A box in Excel that has formulas.
The intersection of a column or row in a worksheet or table.
Fx Bar where you input data.
What is a spreadsheet?
An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.
An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.
An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.
An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.
What is a sheet in Excel?
A single document that typically contains labels, values, formulas, functions, and graphical representations of data.
A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.
A single template that typically contains labels, values, formulas, functions, and graphical representations of data.
A single file that typically contains labels, values, formulas, functions, and graphical representations of data.
What is the Sum formula?
Sum( )
Sum( )=
=Sum( )
=( )Sum
When starting a formula what is the first thing you type in the cell?
+
-
%
=
When you open Excel you are viewing Excel in the ____ View?
Backstage
Frontstage
Spreadsheet
Template
Excel spreadsheets that are already created and ready for you to edit are known as?
spreadsheets
templates
data inputs
pages
What is the green bar at the top of Excel referred to as?
the data bar
the function bar
the ribbon
the row
Excel is useful for using ________ as opposed to words or presentations?
Excel is useful in presenting
Excel is useful in documents
Excel is useful in numbers
Excel is useful in publishing
To quickly add a set of number you can use the ____ feature?
Plus Sum Button
Add Sum Button
Quick Add Button
Auto Sum Button
The letters in Excel represent the _______?
columns
rows
data
functions
The numbers in Excel represent the _____?
columns
rows
data
functions
When making a graph whats the first thing you need to do?
Pick the type of Graph
Use the function = sign
Highlight your data being used.
Double click the active cell
A function in Excel is represented by what to letters?
f( )
xF
xf
fx
Where is the zoom function located in Excel?
Bottom right of spreadsheet document
Bottom left of spreadsheet document
Top right of spreadsheet document
Top left of spreadsheet document
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
What version of Excel are we using in class?
Excel 2016
Excel 2017
Excel 2018
Excel 2015
Excel is part of?
PowerPoint
Microsoft Office Suite
Access
What image represents Excel?
