Take Some Basic Computer Skills Questions

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Twerth
T
Twerth
Community Contributor
Quizzes Created: 1 | Total Attempts: 249
Questions: 10 | Attempts: 249

SettingsSettingsSettings
Take Some Basic Computer Skills Questions - Quiz

.


Questions and Answers
  • 1. 

    Which programs are Web Browsers?

    • A.

      Internet explorer, mozilla firefox

    • B.

      Microsoft word, adobe reader

    • C.

      Java, microsoft outlook

    • D.

      My documents, email

    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.

    Rate this question:

  • 2. 

    What is a file extension?

    • A.

      The program which opens the file

    • B.

      The letters after the period (.) in the filename

    • C.

      A shortcut to the file

    • D.

      The name of the folder where the file is located

    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.

    Rate this question:

  • 3. 

    How can you resize a window to whatever size you want?

    • A.

      Clicking the X icon at the top right of the window

    • B.

      By going to 'Window" the 'Resize"

    • C.

      You cannot make it any size you want, only full-screen or minimized

    • D.

      By clicking and dragging on the edges of the screen

    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.

    Rate this question:

  • 4. 

    A fast way to add up a column of numbers is to click in the cell below the numbers and then:

    • A.

      Click Subtotals on the Data menu

    • B.

      View the sum in the formula bar

    • C.

      Click the AutoSum button on the Standard Toolbar the press ENTER

    • D.

      Use a calculator then type in the answer

    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.

    Rate this question:

  • 5. 

    How do you change column width to fit the contents?

    • A.

      Single-click the boundary to the left of the column heading

    • B.

      Double-click the boundary to the right of the column heading

    • C.

      Press ALT and single-click anywhere in the column

    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.

    Rate this question:

  • 6. 

    ####### means:

    • A.

      You have entered a number wrong

    • B.

      You have misspelled something

    • C.

      The cell is not wide enough

    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.

    Rate this question:

  • 7. 

    Can an Excel spreadsheet be used as the "data source" for a  Word Mail Merge

    • A.

      Yes

    • B.

      No

    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.

    Rate this question:

  • 8. 

    Is it possible to insert an image from a file into an Excel spreadsheet?

    • A.

      Yes

    • B.

      No

    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.

    Rate this question:

  • 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?

    • A.

      Count

    • B.

      Average

    • C.

      Sum

    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.

    Rate this question:

  • 10. 

    To save an Excel spreadsheet as a csv file you would

    • A.

      Save as an Excel Workbook

    • B.

      Save as an Excel Macro-Enabled Workbook

    • C.

      Save as Other Format

    • D.

      Save as Open Document Spreadsheet

    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.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Nov 16, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 04, 2016
    Quiz Created by
    Twerth
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.