Font size
WorksheetsApplied Productivity Tools using Spreadsheet
Total questions: 14
Worksheet time: 9mins
Harold wants to drag select cells A1 to D7. How can he accomplish this?
Long press Alt then click A1 then click D7.
Select A1 then D7 while pressing shift
Type A1:D7 in the formula bar
Press Ctrl + A.
What is the formula that will subtract the contents of the cells A7 to A8?
A7 - A8
= A7 - A8
A7 - A8 =
=SUM (A7:A8)
How can you create a new tab in Windows Excel?
In the ribbon, select Home>Tabs>Add Tabs then input how many you like to add.
Press Ctrl + A then press Ctrl + Shift + n.
You can’t add tabs in Microsoft Excel.
In lower portion of the work area, press the plus button besides the tabs.
How to format a cell that will automatically add a peso sign?
Select the cell or cells you want to edit then press Insert > Symbol > More Symbols.
Scroll down and look for the peso sign then press insert.
Select the cell or cells you like to add formatting. Press right click then click Symbol >
More Symbols. Scroll down and look for the peso sign then press insert.
In the ribbon, select the Home tab then click Format Cells. In the Number tab, click
Currency then in the dropdown box search for the peso sign symbol.
Select the cell or cells you like to add formatting press right click then Format Cells.
Then in the Number tab, click Currency then in the dropdown box search for the peso
sign symbol.
What computer program that gives the user the ability to create tables and edit their values.
Presentation
Word
Spreadsheet
Outlook
Which Ribbon Menu is needed to be selected to change the font?
Home
Insert
Page Layout
Cell Formatting
How do you resize a column or width?
Select the cell the press right click, select format cell then change height and width values.
In the Formula bar type (h[value]:w[value]).
Click the cell then in the ribbon select format cell then change height and width values.
Click and drag the column or row heading
What is the formula that will add the contents of the cells C1 and C10?
(a)
Which Ribbon Menu is needed to add a Chart?
Home
Insert
Page Layout
Cell Formatting
With this formula = Expense!C12, what does the Expense! part means?
It a variable that allows quick reference of a value.
It is formula label, allowing the user to manage all the formula.
It indicates that the c12 to be displayed is on the sheet Expense
This is not a proper use of the formula.
shortcut key for Copy
Ctrl + c
Ctrl + v
Ctrl + B
Ctrl + I
shortcut key for Paste
Ctrl + c
Ctrl + v
Ctrl + B
Ctrl + I
shortcut key for Bold
Ctrl + c
Ctrl + v
Ctrl + B
Ctrl + I
How do you rename a graph into “First Data” in Microsoft Excel?
Press right click then select rename, a window will appear then type “First Data”.
Press Ctrl + A then Ctrl + R, rename the chart to “First Data”
Double click the name of the chart and type “First Data”.
Graph names can’t be changed as they follow the name from the selected data.
