1.
Which programs are Web Browsers?
Correct Answer
A. Internet explorer, mozilla firefox
Explanation
Internet Explorer and Mozilla Firefox are web browsers because they are software applications that allow users to access and view websites on the internet. They provide a graphical interface for users to navigate the internet, display web pages, and interact with online content. On the other hand, Microsoft Word, Adobe Reader, Java, Microsoft Outlook, My Documents, and Email are not web browsers. They are different types of software applications used for word processing, document viewing, programming, email management, and file storage.
2.
What is a file extension?
Correct Answer
B. The letters after the period (.) in the filename
Explanation
A file extension refers to the letters that appear after the period (.) in a filename. It is used to identify the file type or format, which helps the operating system or software determine how to open and interpret the file correctly. For example, a file with the extension ".txt" indicates that it is a text file, while a file with the extension ".jpg" indicates that it is an image file in JPEG format.
3.
How can you resize a window to whatever size you want?
Correct Answer
D. By clicking and dragging on the edges of the screen
Explanation
By clicking and dragging on the edges of the screen, you can resize a window to whatever size you want. This allows you to manually adjust the width and height of the window by dragging its edges inwards or outwards. This gives you the flexibility to customize the window size according to your preferences and needs, making it larger or smaller as desired.
4.
A fast way to add up a column of numbers is to click in the cell below the numbers and then:
Correct Answer
C. Click the AutoSum button on the Standard Toolbar the press ENTER
Explanation
To quickly add up a column of numbers in Excel, you can click on the AutoSum button on the Standard Toolbar and then press ENTER. This will automatically insert the SUM function in the cell below the numbers and display the sum of the column. It is a faster and more efficient method compared to using other options such as Subtotals on the Data menu or manually typing the formula in the formula bar.
5.
How do you change column width to fit the contents?
Correct Answer
B. Double-click the boundary to the right of the column heading
Explanation
To change the column width to fit the contents in a spreadsheet, you need to double-click the boundary to the right of the column heading. By doing so, the column width will automatically adjust to accommodate the widest content in that column. This allows for better visibility and readability of the data in the spreadsheet.
6.
####### means:
Correct Answer
C. The cell is not wide enough
Explanation
The term "#######" is used to indicate that the cell is not wide enough to display the entire content. When a cell in a spreadsheet or table is not wide enough, the content gets cut off and replaced with a series of pound signs (#######). This serves as a visual indicator that the cell needs to be widened in order to display the complete content accurately.
7.
Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge
Correct Answer
A. Yes
Explanation
An Excel spreadsheet can indeed be used as the "data source" for a Word Mail Merge. This is because Word has the capability to import data from Excel and merge it into a document. By linking the Excel spreadsheet as the data source, Word can pull the required information and populate it into the desired fields in the document, making it a convenient way to create personalized documents such as letters or labels.
8.
Is it possible to insert an image from a file into an Excel spreadsheet?
Correct Answer
A. Yes
Explanation
It is possible to insert an image from a file into an Excel spreadsheet. Excel allows users to insert various types of objects, including images, into a worksheet. This can be done by using the "Insert" tab in the Excel ribbon and selecting the "Pictures" option. Once selected, users can browse their computer for the desired image file and insert it into the spreadsheet.
9.
Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
Correct Answer
C. Sum
Explanation
The SUM formula can add all the numeric values in a range of cells, ignoring those that are not numeric, and place the result in a different cell. The SUM formula is specifically designed for adding numbers and will automatically exclude any non-numeric values in the range. This makes it a suitable choice for this scenario, as it allows for easy calculation of the total sum of the numeric values in the range.
10.
To save an Excel spreadsheet as a csv file you would
Correct Answer
C. Save as Other Format
Explanation
To save an Excel spreadsheet as a csv file, you would choose the "Save as Other Format" option. This option allows you to save the file in a different format than the default Excel formats. CSV (Comma Separated Values) is a common format used for storing tabular data, where each value is separated by a comma. By choosing the "Save as Other Format" option, you can then select the CSV format and save the Excel spreadsheet as a csv file.