Lesson 4.2 - Applied Productivity Tools using Spreadsheet
Lesson 4.2 - Applied Productivity Tools using Spreadsheet
What is the formula that will add the contents of the cells C1 and C10?
- C1 + C10
- C1 + C10 =
- = C1 + C10
- SUM (C1
With this formula = Expense!C12, what does the Expense! part means?
- It is formula label, allowing the user to manage all the formula.
- This is not a proper use of the formula.
- It a variable that allows quick reference of a value.
- It indicates that the c12 to be displayed is on the sheet Expense
Which Ribbon Menu is needed to add a Chart?
- Home
- Cell Formatting
- Insert
- Page Layout
Based on the activities, what is the use of a Spreadsheet software?
- It gives the user the ability to create tables.
- It enables users to record words and numbers.
- It allows the data to be stored, organized and analyzed.
- It is a software that allows input, editing, formatting and output of text
How do you change formula style in a sheet?
- You have to select each cell then add cell borders to each of them
- Click Insert > Cell Formatting > Table Format > Table Style
- Click Cell Formatting > Format Table > Table Style
- Click Home > Format as Table > Table Style
How do you rename a graph into “First Data” in Microsoft Excel?
- Graph names can’t be changed as they follow the name from the selected data.
- Press Ctrl + A then Ctrl + R, rename the chart to “First Data”
- Double click the name of the chart and type “First Data”.
- Press right click then select rename, a window will appear then type “First Data”.
How do you assign which cell the formula = (A1 + A2) + A3 will be displayed on?
- In the ribbon click Cell Formatting then select the formula then type where it will displayed.
- Press right click then select Cell Format then click on the Formula tab, type which cell you want that formula will be displayed
- On the formula bar type cell address
- Type the formula where you want it to be displayed on.
What is the formula that will subtract the contents of the cells A7 and A8?
- A7 - A8
- =SUM (A7
- = A7 - A8
- A7 - A8 =
What is the purpose of the Formula Bar?
- It allows an easy to see input box for formula in a cell
- The Formula Bar is a label below the cell that indicates the result of a formula
- It is the formula that allows computation of values from different cells.
- It is a selection of shortcuts different formula in Microsoft Excel
How to format a cell that will automatically add a peso sign?
- 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 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 Format Cells. Then 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 click Symbol > More Symbols. Scroll down and look for the peso sign then press insert.
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]
- Click and drag the column or row heading.
- Click the cell then in the ribbon select format cell then change height and width values.
How do you resize a graph?
- Select the table then press right click, a window will appear, select the Width change the value desired then select height change the value desired.
- Click the graph then click and drag any of the eight handles in the edges of the graph.
- Select the table the press Ctrl + Arrow Keys.
- You can’t change the size of graphs.
Harold wants to drag select cells A1 to D7. How can he accomplish this?
- Press Ctrl + A.
- Long press Alt then click A1 then click D7.
- While pressing shift select the A1 then D7
- In the formula bar type A1
How can you create a new tab in Windows Excel?
- Press Ctrl + A then press Ctrl + Shift + N.
- In lower portion of the work area, press the plus button besides the tabs.
- In the ribbon, select Home>Tabs>Add Tabs then input how many tab you like to add.
- You can’t add tabs in Microsoft Excel.
Which Ribbon Menu is needed to be selected to change the font?
- Cell Formatting
- Home
- Insert
- Page Layout
Lesson 4.2 - Applied Productivity Tools using Spreadsheet
Reviewed by Rainville Raqueno
on
October 10, 2022
Rating: 5
No comments