NEW
Font size
Worksheets3Q ICT8
Total questions: 60
Worksheet time: 30mins
In a school, Maya is learning how to use a spreadsheet for her project. She discovers that the point where a specific row and column meet is crucial for entering her data.
Cell
Row
Column
Tab
James is working on a project in Excel and needs to move around the spreadsheet efficiently.
By pressing the space bar
By using the mouse and arrow keys on the keyboard
Through the menus on the ribbon
Abigail is working on a spreadsheet for her project. How does she determine the selected cell in her spreadsheet?
The row is highlighted
The Black border around it and the content of the cell will appear at the formula bar
The cell address will appear on the status bar
The column is highlighted.
Grace is working on a project in her spreadsheet application. She wants to create a new workbook but also save a copy of her current workbook. Which of the following commands should she use?
Save As
Open
Copy
Save
Priya is working on a spreadsheet and wants to adjust the column width to fit the contents of her data. How does she do that?
Drag the boundary to the left or to the right
press Ctrl key and click the boundary
press Alt key and click the boundary
Double click the boundary
In a classroom, Elijah is organizing a spreadsheet for the science project. He wonders, what is the column heading composed of?
Letters
Numbers
Cells
Sheet tabs
After Jackson inputs any character in a cell of his spreadsheet, what will he do next to accept it?
Press enter key
Press esc key
Press ctrl key
Press alt key
Emma is working on a project in MS Excel where she needs to include a picture. She wonders if she can insert a picture and resize it to any size she desires.
True
False
You can insert picture only
You cannot resize the picture you’ve inserted
Ava is trying to calculate her monthly expenses using MS Excel, just like she would with a calculator.
True
False
In top row only
Only in first row
Mia is trying to enter data into an Excel spreadsheet for her budget. She believes that only numbers can be entered into the cells. Is she correct?
The statement above is true
The statement above is not true
The statement above is sometimes true
The statement above is possible based on how the cell/s is/are formatted.
Avery is working on a large project in her workbook and needs to find specific data quickly. She remembers that she can easily search any data from her workbook using the Find feature or Ctrl + F.
The statement above is true
The statement above is not true
The statement above is sometimes true
None of the Above
During a team meeting, Sophia decides to add a new column to the project spreadsheet. She wonders where the new column will appear in relation to her current selection. She thinks, "When I insert a new column, it will appear on the left of the selected cell/column."
The statement above is true
The statement above is not true
The statement above is sometimes true
None of the Above
James is working on a project and wants to print his worksheet. He remembers that Ctrl + P is the shortcut for printing.
The statement above is true
The statement above is not true
The statement above is sometimes true
David wants to apply the same formatting of a selected cell in his spreadsheet to another cell(s) using Format Painter.
The statement above is true
The statement above is not true
The statement above is sometimes true
None of the Above
Liam is working on a spreadsheet for his school project. From the Home tab, he can click this button to apply fill color to a selected cell or a range of cells.
The statement above is true
The statement above is not true
The statement above is sometimes true
None of the Above
In a spreadsheet application, Rohan is trying to understand what a cell is. He learns that a cell is defined as:
To save a workbook
A command to create a copy of a workbook while keeping the original.
the intersection of a row and a column
contains multiple tabs, each with several groups of commands.
Ava is working on a project in her spreadsheet application and wants to ensure she doesn't lose her progress. She decides to use the 'Save As' feature.
To save a workbook
A command to create a copy of a workbook while keeping the original.
the intersection of a row and a column
contains multiple tabs, each with several groups of commands.
While working on a project, Ethan frequently uses the shortcut Ctrl + S to ensure he doesn't lose any progress.
to save a workbook
A command to create a copy of a workbook while keeping the original.
the intersection of a row and a column
contains multiple tabs, each with several groups of commands.
Harper is working on a project in a software application that uses a Ribbon interface.
To save a workbook
A command to create a copy of a workbook while keeping the original.
the intersection of a row and a column
contains multiple tabs, each with several groups of commands.
In a busy office, Anika is trying to explain to her colleague Daniel how to efficiently use the software they are working with. She says, 'Let me tell you about a feature that can really help you.'
the intersection of a row and a column
To save a workbook
A command to create a copy of a workbook while keeping the original.
box works like a search bar to help you quickly find tools or commands you want to use.
Abigail is working on a large spreadsheet for her project. She needs to navigate through the data efficiently. What is the purpose of the horizontal navigation bar in the spreadsheet?
To move the view of the spreadsheet on the left or right of the screen
To move the view of the spreadsheet on the top or bottom of the screen
To add columns
To add rows
Ava is working on her computer and needs to look at a long document. She notices that the content extends beyond the visible area of her screen. To see the rest of the document, she uses the vertical scroll bar. What is the purpose of the vertical scroll bar?
Navigating the screen upward and downward
Viewing the left and right part of the screen
Adding columns
Adding rows
Anika is working on a spreadsheet and has just typed some important data into a cell. After entering the information, which keyboard button should she press to "accept" the content she entered?
Enter
Esc
Tab
Spacebar
Evelyn is working on a spreadsheet and she selects a cell that already contains some data. What happens if she starts typing or inserting numbers into that cell?
The above action will add the additional text and/or numbers to the end of the existing contents of the cell.
The above action will delete the current contents of the cell and replace it with the next typed text or numbers.
The text or numbers you type will automatically be appended to the end of the existing contents of the cell.
Nothing will happen. It is not possible to replace the contents of an existing cell.
Rohan is working on an important project in his workbook. He wants to create a backup copy of his workbook to ensure he doesn't lose any data. To do this, he needs to choose a different name and/or location for the copied version. What do you call this command?
Save as
Delete
Save
Export
Zoe has just finished her project and wants to share it with her classmates. She needs to produce a hard copy of her work.
Save as
Save
Export
Benjamin is working on a project in MS Excel 2016. He wants to save his workbook, but he is unsure about the default file type that Excel uses for saving workbooks. What type of file will his workbook be saved as by default?
.xlsx file
.pptx file
.pdf file
.docx file
Rohan is working on a spreadsheet and needs to identify the Active Cell where he is currently entering data.
To Print a worksheet
Indicated by a dark wide border
An easy and colorful style for cell formatting
Command to automatically arrange the width or height of the cells.
Cell Styles
Command to automatically arrange the width or height of the cells.
To Print a worksheet
Indicated by a dark wide border
An easy and colorful style for cell formatting
Ctrl + P
Command to automatically arrange the width or height of the cells.
To Print a worksheet
Indicated by a dark wide border
An easy and colorful style for cell formatting
Charlotte is working on a spreadsheet for her project. She wants to ensure that all the cells fit the content perfectly without any manual adjustments. What feature should she use?
Combined and center the content of the cells in a new larger cell
Command to automatically arrange the width or height of the cells.
To Print a worksheet
Indicated by a dark wide border
Ethan is preparing a presentation for his class and wants to make the title stand out. He decides to use the 'Merge and Center' feature in his document editor.
To Print a worksheet
Indicated by a dark wide border
An easy and colorful style for cell formatting
Combined and center the content of the cells in a new larger cell
Michael is organizing a large list of contacts in his spreadsheet. He wants to arrange the names alphabetically to make it easier to find specific individuals. Which feature will he use to achieve this?
Filtering
Freezing Panes
Sorting
Inserting Columns/rows
Avery is working on a project report and wants to present her data in a clear format. To format her data as a table, she needs to select from the Table style command. Where can she find this feature from?
Table Style group of the Home tab
Design Tab
Predefined table styles
Table style option
During a team meeting, Mia wants to combine several cells in a spreadsheet to display data without centering the text. She wonders which command she should use to achieve this.
Merge and center command
Merge cell command
Merge across command
Unmerge cells command
While working on an important project, Anika was using a Spreadsheet to organize her data. She was making significant changes when suddenly her computer crashed. Fortunately, she remembered that the Spreadsheet automatically saves the workbook to a temporary folder. If she forgets to save her changes or if the Spreadsheet crashes, she can restore the file using what type of command?
Save as
System Recovery
Delete
Auto Recovery
Avery is organizing a spreadsheet for her school project. She needs to refer to a specific section of the spreadsheet that includes multiple data points. What does cell reference A1:D10 mean?
Range of cells from column A to column D
Selected cells A1 and D10
Range of cells from column A to row 10
Range/block of selected cells from cell A1 to cell D10
Arjun is trying to create a budget spreadsheet in Excel. He knows that every formula in Excel begins with what character?
Equals sign
Plus sign
Minus sign
Forward slash
During a team project, Priya needs to calculate the total expenses for their event. She realizes that the cell reference is __
Used to identify the cells to be calculated
Can be used in creating a formula
An element of a formula in Excel
All of the above
James is planning a party and needs to calculate the total cost of decorations. He has a budget of 40 dollars. If he spends (2 + 2) dollars on balloons and then buys decorations that cost 8 dollars each, dividing the total cost by 2, how much money will he have left after the purchases?
160
30
24
144
Liam is planning a small party and needs to calculate the total number of snacks he can buy. He has a budget of $48. If he decides to buy a snack pack that costs $12 and includes 2 snacks, how many packs can he buy if he also wants to save $2 for drinks? Use the PEMDAS rule to solve the equation 48−(12+2)×2÷5 to find out how many packs he can afford.
41.2
34.4
42.1
34
Aiden is planning a party and needs to calculate the total cost of decorations. He has a budget of 4−(2+42)×8÷2 dollars. If he follows the PEMDAS rule to solve this equation, what total amount will he have left for snacks?
170
172
171
169
Ava is planning a small party and needs to calculate the total number of snacks she can buy. She has $40 to spend. If she decides to buy 5 packs of chips, each costing $2, and she wants to buy some cookies that cost $8 per pack, how many packs of cookies can she buy after buying the chips?
52
57
32
37
Benjamin is planning a party and needs to calculate the amount of food he can buy with his budget. He has $40 to spend. If he decides to divide his budget among 2 friends who are helping him, and they agree to spend the remaining amount on food that costs $8 per unit, how much money will Benjamin have left after buying the food?
34
-34
-0.75
0.75
Grace is organizing her sales data in Excel and she uses the range A1:C8 to summarize her performance.
A1 times C8
Sum of A1 to C8
A range of cell from A1 to C8
Value of cell
Anika is working on a spreadsheet and wants to quickly fill in a series of numbers in the adjacent cells. She decides to use the fill handle to:
Copy the formula to the cell(s) adjacent to it
Copy the text to the adjacent cell(s)
Zoe is creating a budget spreadsheet for her monthly expenses. She uses a formula to calculate her total spending in a specific category, and she wants to ensure that the reference to her total income remains constant when she copies the formula to other cells. She designates her total income cell as D$5. What does D$5 mean in this context?
The column and the row do not changed when copied
The row does not change when copied
The Column does not changed when copied
The row and column will be changed
Ava is trying to calculate her monthly expenses using Excel. She knows that to enter a formula correctly, a Formula in Excel must___
begins with an equal’s sign
contain function
not have space
All of the above
Abigail is working on a large spreadsheet for her project. She wants to keep certain column(s) and/or row(s) displayed while she scrolls through the rest of the data. What feature should she use to achieve this?
Filtering
Freezing Panes
Deleting Columns
Deleting Rows
Maya is working on a large spreadsheet for her project, and she needs to view specific data while keeping the headings visible. What feature of the spreadsheet can help her achieve this?
Filtering
Freezing Panes
Deleting Columns
Deleting Rows
Benjamin is organizing a large collection of books in his library. He wants to arrange the books alphabetically by title, numerically by publication year, or in a custom order based on his preferences. To achieve this, he will be using this feature.
Filtering
Freezing Panes
Deleting Columns
Deleting Rows
Study Picture A. The data is sorted ____
A to Z
Z to A
Based on the length of Text
Based on the font size
During a team meeting, Aria presented a type of chart in MS Excel 2016 that used vertical bars to represent the sales data for the last quarter.
Column chart
Pie chart
Line chart
Bar chart
In a busy office, William needs to ensure that the sales data in the spreadsheet is easily readable and highlights important figures. He wants to mark, format, or perform actions based on specific rules or conditions he creates for the data.
Conditional Formatting
Highlight cells function
Top/Bottom Rules
Color Scales
Avery is working on a project report and wants to present her data in a clear format. To format her data as a table, she needs to select from the Table style command. Where can she find this feature from?
Table Style group of the Home tab
Design Tab
Predefined table styles
Table style option
In a financial planning meeting, Maya uses the Goal Seek tool, a feature of the What-if Analysis in her spreadsheet, to help her determine how much she needs to save each month to reach her target savings goal. This can help her to___
Experiment and answer questions with your data
Try different values for the formula
Test multiple values and see the result change
Use several values in one or more formulas to test various result
After receiving the test scores of Grade 8-Gumamela from your teacher, you are tasked with identifying the top 10 students. How will you apply your knowledge in MS Excel 2016?
By using Find feature
copy and paste the score’s column to other sheet and sort it to find the top Ten high scores
Apply filtering
Use Top/Bottom rules from Conditional Formatting command
Lily is managing a large dataset for her school project. She needs to quickly display summary rows or columns to group and summarize the list of data in her spreadsheet. This feature is located in the Outline group of the Data tab.
Outlining
Sorting
Filtering
Conditional Formatting
Grace has a data range in her spreadsheet and she wishes to format it as a table. What step from the options below is she going to perform?
Select range of cells you want to format as a table. On the Home tab, click Format as Table. Select any table style you want to use.
Select range of cells you want to format as a table. On the Data tab, click Format as Table. Select any table style you want to use.
Select range of cells you want to format as a table. On the Insert tab, click Format as Table. Select any table style you want to use.
Select range of cells you want to format as a table. On the Format tab, click Format as Table. Select any table style you want to use.
Grace is organizing a community event and needs to combine several cells in a spreadsheet to display the participants' names without centering the text. This is possible in ___
Merge and center command
Merge cell command
Merge across command
Unmerge cells command
