NEW
Font size
WorksheetsExcel 3
Total questions: 19
Worksheet time: 7mins
What is the keyboard shortcut key to lock cell references in a formula?
CTRL
ALT
F2
F4
What are the shortcut keys for AutoSum?
ALT and S
CTRL and S
ALT and =
CTRL and =
Which of the following is the correct formula to calculate the weighted average score in cell C8 as shown below?
=SUMPRODUCT(C2:C5,B2:B5)
=SUMPRODUCT(C2:C4,B2:B4)
=AVERAGE(B2:B4)
=AVERAGE(C2:C4)
Company A is looking into four potential projects and will accept them if the IRR is 10% or above, as shown in cell E2. What is the formula used in cell C2, which can be copied down to cell C3 through C5, to generate the results shown below?
=IF(B2>=E2,"Accept","Reject")
=IF(B2>=$E2,"Accept","Reject")
=IF(B2>=E$2,"Accept","Reject")
=IF(B2>=$E$2,"Accept","Reject")
What are the shortcut keys to insert a new row in an Excel spreadsheet?
ALT + H + I + R
ALT + H + I + C
ALT + H + I + I
ALT + H + I + S
Which of the following Excel features allows you to select/highlight all cells that are formulas?
Find
Replace
Go To
Go To Special
What formula should be entered in cell A3 to display the results as shown below?
="Income Statement"&A1
="Income Statement "&A1
="Income Statement "+A1
="Income Statement "&"A1"
What formula can be used in cell G2 to create a dynamic date which shows the last day of each month?
=EOMONTH($B$2,B1)
=EOMONTH($B$2,G1)
=EOMONTH($B$2,C1)
=MONTH($G$2)
Assuming cell A1 is displaying the number "12000.7789". What formula should be used to round this number to the closest integer?
=MROUND(A1,100)
=MROUND(A1,10)
=ROUND(A1,0)
=ROUND(A1,1)
What are the keyboard shortcut keys to edit formula in a cell?
F2
F4
CTRL + 1
CTRL + F
In which tab of the ribbon can you change Workbook Views to Page Break Preview?
View
Review
Page Layout
Data
Which of the following features cannot be found in the Data ribbon?
What-If Analysis
PivotTable
Data Validation
Text to Columns
Suppose a company expected its revenue to be $180,000 for 2014-2018. What formula should be entered in cell E6 so it displays revenue in 2016 if it was above budget, otherwise it'll show 0?
=IF(E2<$B$6,E2,0)
=IF(E2<$B$6,0,E2)
=IF(E2>$B$6,E2,0)
=IF(E2>$B$6,0,E2)
How should the following formula be written: Multiply Cell A1 by 6, and divide that by 4?
=A1X6/4
=A1X6%4
=A1*6/4
=A1*6%4
The Conditional Formatting feature is used to:
Set the default cell format
Format conditional statements
Format cells conditional on the text size
Change the style of cells meeting a condition
Which action are you supposed to perform first before applying Subtotals to the data in the image?
Format the data in column B
Format the data in column A
Sort the data in column A
Sort the data in column B
Which file format can be added to a power point show?
.gif
.jpg
.wav
All of above
How to select one hyperlink after another during a slide presentation?
Ctrl+K
Ctrl+D
Ctrl+H
Tab
Which power point view works best for adding slide transition?
Animations
Chart Wizard
Transition Wizard
Auto Content Wizard
