Question

NEED FIVE QUESTIONS ANSWERED!!!

Question 1 Excel is a tool used to
A create a spreadsheet
B design a brochure
C make a presentation
D write a letter
Question 2 A cell on an Excel spreadsheet refers to
A a type of document view
B a page of the workbook
C the rectangular box where a column and row intersect
D the data in a worksheet
Question 3 Tanya is entering the amount of money she has earned from babysitting onto an Excel spreadsheet, but the AutoComplete feature is not working. Why?
A AutoComplete must be turned on before every entry.
B AutoComplete only works with professional spreadsheets.
C AutoComplete does not recognize types of currency.
D AutoComplete only works when the first character is text.
Question 4 Which tab has formatting features to change the font style, color, size, and alignment?
A File
B Home
C Insert
D View
Question 5 Brad uses Excel to create a weekly schedule. He wants to keep using the same spreadsheet every year. One of his rows is titled "Baseball," but the season has ended until next year. What is the most efficient way to modify the spreadsheet, so Brad does not see Baseball on his schedule but can easily get it back when the season starts again?
A Add a new comment with the start date of the next season
B Hide the row and unhide it when the new season begins
C Highlight the row in a different color to show the season has ended
D Start a new spreadsheet

Answer 1

Answers:

A. Create a spreadsheet

The MS Excel software is a type of software that allows users to create spreadsheets that can contain a large number of data. These spreadsheets are mainly used to store information of businesses or simply used to organize different information in a table like form.

C. The rectangular box where a column and row intersect

A cell is a rectangular box where a column and row intersect in a spreadsheet. These cells can store one piece of data at a time and have unique coordinates to separate them from each other.

D. AutoComplete only works when the first character is a text.

The AutoComplete feature in MS Excel is a feature that can give a suggestion of what the user is trying to input into a cell. This feature will only work when a user inputs a text (e.g. A to Z and 0 - 9). If a user inputs a special character, the AutoComplete feature will not be able to recognize it.

B. Home

The Home tab contains the main formatting tools in a spreadsheet. The home tab is one of the most used tabs in MS Excel as most of the inputs in a spreadsheets will most likely need formatting to make it more understandable to the users.

B. Hide the row and unhide it when the new season begins.

The hide feature in MS excel allows users to select a row(s) or column(s) of the spreadsheet to temporarily remove the selected rows or columns and prevent users from editing information in them. The unhide feature will simply reveal the hidden selection to allow the user to edit the information again.