top test question for Microsoft excel with answer

Here are some test questions for Microsoft Excel along with their answers:

What is a spreadsheet, and what are the benefits of using Microsoft Excel for creating and analyzing spreadsheets?

Answer: A spreadsheet is a software program that allows users to organize, analyze, and manipulate data. Microsoft Excel is a popular spreadsheet application that provides users with a variety of features, including the ability to create formulas, charts, and pivot tables. Some benefits of using Excel include its ability to handle large amounts of data, its ease of use, and its compatibility with other Microsoft Office applications.

How do you insert a new row or column into an existing spreadsheet, and what are the keyboard shortcuts for doing so?

Answer: To insert a new row or column into an existing spreadsheet, right-click on the row or column heading where you want to insert the new row or column and select "Insert." Alternatively, you can use the "Insert" command on the "Home" tab of the ribbon. The keyboard shortcuts for inserting a row or column are "Ctrl" + "+" and "Ctrl" + "Shift" + "+" on Windows, and "Command" + "+" and "Command" + "Shift" + "+" on Mac.

What is the difference between a relative and an absolute cell reference, and how do you use each of them in a formula?

Answer: A relative cell reference in a formula refers to a cell's position relative to the cell that contains the formula. For example, if you copy a formula that refers to cell A1 to cell B1, the formula will automatically update to refer to cell B1. An absolute cell reference, on the other hand, refers to a fixed cell, regardless of the position of the formula. Absolute cell references are denoted by adding a "$" symbol before the row or column reference in the formula. For example, if you want to refer to cell A1 in a formula regardless of the position of the formula, you would use the absolute reference "$A$1".

How do you create a pie chart or a bar chart based on data in an Excel spreadsheet, and what are the different chart types available in Excel?

Answer: To create a pie chart or a bar chart in Excel, select the data range that you want to use for the chart and go to the "Insert" tab of the ribbon. From there, select the chart type you want to create (e.g., pie chart, bar chart) and choose a specific chart style. Some of the different chart types available in Excel include column charts, line charts, scatter charts, and area charts.

What is conditional formatting, and how can it be used to highlight cells based on specific criteria?

Answer: Conditional formatting is a feature in Excel that allows users to apply to format (e.g., font color, cell color, bolding) to cells based on specific criteria. For example, you could use conditional formatting to highlight all cells in a range that contain a certain value or fall within a certain range. To apply conditional formatting, select the cells you want to format, go to the "Home" tab of the ribbon, and click the "Conditional Formatting" button. From there, select the formatting rule you want to apply and specify the criteria for the rule.

How do you use the VLOOKUP function in Excel, and what are some common scenarios where this function might be useful?

Answer: The VLOOKUP function in Excel allows users to look up a value in one table and return a corresponding value from another table. To use the VLOOKUP function, you need to specify the value you want to look up, the range of cells you want to search for the value, the column number of the value you want to return, and whether you want an exact match.

Comments

Post a Comment

Popular posts from this blog

Odesk Skill test question Windows XP

http://www.neobux.com/?r=Reall5 Question: Which of the following statements about the Stand By option while shutting down your computer is/are correct?  a.  It waits for 5 minutes before shutting down the computer.  b.  It helps to conserve power by shutting off some hardware, like the hard disk.  c.  It shuts down the computer for a specific time and then restarts it.  d.  Stand By will save your desktop and all open files to a special Windows file called hiberfil.sys. This file usually resides in the computer's root folder (C:\hiberfil.sys).  Question: The hard-drive utility tool in Windows XP for automatically fixing file system errors or for searching for and attempted recovery of bad sectors is:  a.  CheckDisk (CHKDSK)  b.  SystemCheck (SYSCHK)  c.  DiskFix (DSKFX)  d.  DiskScan (DSKSCN) Question: You are logged in as an administrator to the computers on your small local network and you want to change the names of those computers and the workgroup so that their
Read more

ODESK SKILL TEST QUESTION MS WORD 2010

            ODESK SKILL TEST QUESTION MS WORD 2010 If you want to create a citation and fill in the source information later, you should: a. insert a caption. b. add a placeholder. c. add a new source. d. insert a cross-reference. A To select vertical blocks of text, you would hold down which key while dragging the mouse? a. Alt b. Ctrl c. Shift b If I do not want the contents of one of my fields to automatically update, I would have to do which of the following? a. Lock the field. b. Protect the field. c. Make the field hidden. d. Turn field shading off. C Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to b
Read more

Odesk Skill Test Question ACCOUNTING

                                                       ODESK http://www.neobux.com/?r=Reall5               ODESK : Changing How the World Works.    Item No: 1 of 40             Time Remaining: 0:40:00   Question: What is the accounting objective which best relates to the MACRS method?   a.        Income Smoothing b.         Profit Maximization c.         Tax Minimization d.         None of the above                           ODESK    : Changing How the World Works. http://buxify.com/?r=reall   Item No: 2 of 40                Time Remaining: 0:39:20   Question: What statements are required of a Non-Profit organization? http://bux.to/?r=reall1   a.         statement of financial position, statement of cash flows, and statement of activity and changes in net assets b.         Bank Statements c.         Cash Flows and Income Statement d.         Changes in retained earnings, statement of cash flows, income statement                         http://www.hiphopmails.com/pages/
Read more