NEW
Font size
WorksheetsExcel for starter
Total questions: 40
Worksheet time: 20mins
In the Excel interface, what is the main function of the Ribbon for beginner users?
Displays organized groups of commands
Automatically draws charts
Sends emails directly from Excel
Saves files and closes the program
Which group in the Home tab is used for copying, cutting, and pasting?
Alignment
Font
Number
Clipboard
If you want to change the font type and text size in a cell, which group in the Home Tab should you open?
Editing
Styles
Alignment
Font
You want to center the text in a cell. Which group is the most appropriate to use?
Clipboard
Alignment
Number
Cells
A student needs to change the number format to percentage. Where is this feature usually found?
Editing
Styles
Number
View
The most logical sequence of steps to speed up work when formatting a table:
Open View, set zoom, save file
Use Find first, delete all data
Click Insert, select chart, change theme
Select cells, use Font then Alignment
What is the main function of the Clipboard in the Home tab of office applications?
Remove viruses from the computer
Create automatic graphs and diagrams
Change the layout of the document page
Temporarily store a copy of text
Which button is used to move text from the original place to a new place without leaving a copy?
Delete then Paste
Copy then Paste
Cut then Paste
Paste then Copy
You want to paste the text that has been copied. What is the correct sequence of steps?
Select text, Paste, then Copy
Select location, Cut, then Paste
Select location, Paste, then Copy
Select text, Copy, select location, Paste
In the Font group, which tool is used to bold the text in the title?
Button B Bold
Button I Italic
Button A Text Color
Button U Underline
You are asked to make the title more prominent. Which change is most appropriate to make in the Font group?
Change the font type and increase the size
Remove the paragraph and reduce the margin
Activate gridlines and freeze pane
Change the date format to numbers
A friend wants to color important text. Which feature in the Font group should be used?
Align Center in the paragraph
Clear All in the Clipboard
Increase Indent right arrow
Font Color with the A letter icon
In Excel, what is the Alignment button in the Home Tab used for?
Delete all table contents
Insert a chart into the worksheet
Calculate the total of the entire column
Adjust the position of text within a cell
If you want the number 0.25 to be displayed as 25%, which format should be selected in the Home Tab?
Currency for currency
Time for hours and minutes
Percentage in Number
General without format
What is the correct option to center the table title so that it appears balanced in the middle?
Justify full text
Wrap Text automatically
Align Center horizontally
Align Left at the corner
You want the table to be clearer with borders and background color. Which feature should you use?
Table Style on Home
Flash Fill for patterns
Find & Select quickly
Insert new PivotTable
A friend changed the number format to Currency. What usually happens to the number display?
Completely hidden
Changed to time
Converted to percentage
Currency symbol appears
You have a long column containing descriptive text. To prevent the rows from expanding, which button helps to break the text into a new line within the cell?
Wrap Text in Alignment
Merge & Center merge
Decrease Indent shift
Sort A to Z order
Look at the table diagram on the Excel screen. The column with the yellow header in row 1 contains "No, Name, Gender, Class". What is the function of the "No" column in the table?
Indicates the order of student data
Saves the full name of the student
Determines the gender of the student
Gives background color to the row
On the Home tab in Excel, which tool is most appropriate for creating borders around all table cells to make it look neat?
Zoom in the View group
Border in the Font group
Sort in the Editing group
Insert in the Cells group
Observe the student table. If you want to add a new row for student number 6 below Udin, what is the most appropriate action?
Delete the first row of the table
Change the color of the table header only
Use Insert Row on the Home Tab
Activate Zoom 200 percent
The background color of the cells in the table example varies. What is the purpose of providing a consistent color for the table header?
To make it easier to recognize the column title
To hide the text in the row
To change the cell content to numbers
To automatically count the number of rows
You have a column "Class" containing 1A, 1B, 1C, 1D, 1E. If you want to sort from 1A to 1E using basic features, what is the most appropriate step?
Select the column and click Sort A to Z
Copy the header to the last row
Select all and click Merge Cells
Change the cell color to green
When editing a table in the Home Tab, you want to bold the text in the column header to make it clearer. Which button should you select?
Bold in the Font group
Filter in the Sort group
Wrap Text in the Alignment group
Paste in the Clipboard group
Which part of the Home Tab is used to copy and paste text between cells?
Alignment on the Home Tab
Font on the Home Tab
Clipboard on the Home Tab
Number on the Home Tab
If you want to change the font to bold or italic, which part must you use?
Editing in the Home Tab
Cells in the Home Tab
Number in the Home Tab
Font in the Home Tab
What is the function of the Alignment feature in the Home tab?
Adjust text position
Change number size
Add new lines
Search and select cells
You want to display the value as currency. Which part should be used?
Clipboard to paste
Number for number format
Editing to delete
Font for text color
To add or remove rows/columns, which section in the Home Tab will you select?
Font for text style
Alignment for text alignment
Clipboard for copy paste
Cells for insert delete
A friend wants to speed up data management. Which combination of Home functions would be most helpful?
Clipboard, Font, Alignment
Number, Cells, Editing
Insert, Review, View
Formulas, Data, Page Layout
Why is it necessary to block the range of cells before applying a border?
So that the file can be saved without a name
So that the lines are applied to the selected area
To hide empty columns
So that the data changes to automatic numbers
What is the brief order to create a table with borders?
Write data, click Review, select Protect Sheet
Select one cell, click Bold, then click Insert Table
Click Format as Table, then write data, click Save
Write data, select data, click Border, choose All Borders
After entering data, the action that draws lines on all selected cells is what?
Click Merge & Center on Home
Click Conditional Formatting
Click All Borders on the Border menu
Click Clear on the Editing tab
The first step in creating a table in Excel is what?
Select the NIPD column first
Click All Borders first
Click Blank Workbook first
Select Format as Table
In Excel, what is a worksheet?
Command search box
Working sheet in a workbook
Active file name
Collection of icons on the ribbon
What is the main function of the Name Box when selecting cell A1?
Quickly scroll the page to the left
Automatically change the cell background color
Close the active workbook
Display the text 'A1' as the location name
What is the part that displays numbers on the left side of the worksheet called?
Rows
Columns
Title Bar
Scroll Bar
What is the part that displays letter labels at the top of the worksheet called?
Rows
Column Bar
Name Box
Status Bar
Where can you see the name of the workbook file that is currently open?
Title Bar
Status Bar
Formula Bar
Scroll Bar
What is meant by a cell in a worksheet?
Intersection of a column and a row
Collection of several sheets in a workbook
Place to store the file name
Area to display the program status
