Quizzes

All quizzes in this website, REGISTER FREE to this website for more advanced quizzes and newsletter for update

The 18 Most Asked Excel Questions and Answers when applying for a Job, Will you pass it?

The Excel Quiz is the tool to measure the knowledge of Excel. Employers usually conduct it during the recruiting process. It aims to test the skill level in Excel as it reduces human work and makes it very easy.

1 / 18

What is the formula used for totaling the numbers?

2 / 18

What is the shortcut for activating the previous workbook?

3 / 18

What is the shortcut for selecting the entire column?

4 / 18

What is the shortcut for copying the value from the above cell?

5 / 18

What is the shortcut for copying the formula from the above row?

6 / 18

What is the shortcut for entering the current time?

7 / 18

What is the shortcut to insert the hyperlink?

 

8 / 18

A taken Loan of $ 5,00,000 for 5 years, rate of interest is 9% p.a calculate EMI?

9 / 18

What is the formula for calculating EMI in Excel?

10 / 18

What is the table tool for evaluating and analyzing the data?

11 / 18

What is the Formula for Rounding off the Number fully without any decimal?

12 / 18

An IT Company is looking into three of the potential projects and will accept the project only if the IRR from the project is expected to be 12% or above. What formula shows whether to accept or reject the projects under consideration?

13 / 18

Shortcut for expanding or collapsing the formula bar?

14 / 18

What is a shortcut to insert the table?

15 / 18

How to find the current date and time in excel?

16 / 18

What is the formula for finding the average of numbers?

17 / 18

What is the formula for inserting the Random numbers in excel?

18 / 18

What is the shortcut key for the Autosum?

Your score is

The average score is 0%

0%



0 votes, 0 avg

Comptia A+ Core 1(220-1101)

220-1101 Hardware

CompTIA A+ CORE 1 Hardware Questions PART1

1 / 10

Category: Hardware

To speed up a laptop, you have a request from a client for the following upgrades: upgrade RAM to 8GB and replacing the existing 500GB hard disk with a 1TB SSD.
Which of the following should you do FIRST before you can quote a price and timeframe for this job?

2 / 10

Category: Hardware

220-1101 - Hardware
On 3d printer print bet move down while extruder nozzle move from rigth to left

3 / 10

Category: Hardware

A client has requested your expert advice on a gaming laptop with a 15-inch di splay that will cost about $1,400. Which of the following screen technologies would be the BEST choice for this user?.

 

4 / 10

Category: Hardware

220-1101 Hardware
Select 2 of the most commonly processors found in a server and on a normal PC.

5 / 10

Category: Hardware

A client is generally satisfied with the thin and light laptops in use by her sales force, except that they need
touch screens for more interactive presentations.
Which of the following is the BEST recommendation for this client?

 

6 / 10

Category: Hardware

You have a user who needs advice on installing a home server PC, He wants to be able to exchange files and videos with his family over his home network. In addition, he wants their data to be safe in case of a hard drive failure. Which system components do you thinks should be included?

7 / 10

Category: Hardware

What are three voltages converted by the DC power supply(DCPS) in a laser printer

8 / 10

Category: Hardware

Your client is asking for your help in deciding between two similar laptop computers. Laptop 1 has a Type-C port according to the marketing literature, while Laptop 2 has a USB 3.1 Gen 2 Type-C port according to its marketing literature. The client needs 10Gbps speed to support an additional display and high-speed USB SSDs connected to a Type-C docking station.

9 / 10

Category: Hardware

During the laptop RAM upgrade process (goal: 8GB per system), you determine that some of the computers
have 2x2GB SODIMM RAM modules for a total of 4GB onboard, while others have 1x4GB SODIMM RAM modules for a total of 4GB onboard. All systems have two SODIMM sockets. All of the 4GB memory and 2GB memory have the same form factor (DDR3 SODIMM) and timing. There are 10 systems with 1x4GB modules, and 20 systems with 2x2GB modules. Which of the following purchases will provide 8GB of identical RAM per system without considering spares?

10 / 10

Category: Hardware

You are having a discussion with a new hire in your department. The new hire asks you this question: “Which is better, TCP or UDP?” .

Which of the following is the BEST answer?

Your score is

The average score is 0%

0%



220-1101 Mobile Devices

CompTIA A+ CORE 1 Mobile Questions PART1

1 / 4

What service is incorporate to Apple products that allow users and subscribers to save documents, media and contacts information in their devices?

2 / 4

This feature most be enabled on mobile devices to embed the GPS position into a photograph when using the device's camera?

3 / 4

Your client is planning to use Google Workspace on a 45-minute flight to prepare his presentation after charging his laptop all day. The presentation will be given within a half-hour of arrival, and very little has been completed yet. Which of the following problems could make the presentation preparation difficult?

4 / 4

Your client is using a Bluetooth speaker with two different computing devices. She calls you because after
using the device with her desktop, she was unable to use it with her smartphone, but a new Bluetooth
headset does work with her smartphone. Which of the following is the BEST answer as to why the user can’t
use her speaker with her smartphone?

Your score is

The average score is 0%

0%



CompTIA A+ 220-1101 NetWorking Part 1

1 / 3

Your client has been receiving DNS errors frequently. After consulting with you and changing his DNS servers, he is still getting DNS errors on his previous lookups, but new websites are resolving (being translated from URL to IP address and opening) properly.

What is the BEST suggestion to fix this problem?

2 / 3

Your client has been using POP3 email for several years when she used only a desktop computer. Now, your client has switched to IMAP, but her email client cannot connect to her email box. Her other network and Internet apps work properly.

Which of the following is the MOST LIKELY reason for the problem?

3 / 3

You are researching the electronic services offered by a bank that your company will begin using next month. You want to make sure that web-based banking users make secure connections to the bank server.
Which one of the following protocols would be most appropriate for this use?

Your score is

The average score is 67%

0%



CompTIA A+ 220-1101 Virtualization And Cloud Computing

1 / 3

A software developer, who is using Windows 10 Pro on his SOHO Computer, need to build an application that must operate on both Windows and Linux computers. Therefore, he must get his app tested on both of those environments.

Witch of the following would be the MOST cost- effective solution in this case

2 / 3

Witch of the following would basically the same whether an operating system was run on a virtual server or a physical server?

3 / 3

What are the possible disadvantages of the shared resource structure of public cloud computing?

Your score is

The average score is 0%

0%



CompTIA A+ 220-1101 Hardware And Network Troubleshooting

You need to add questions

Your score is

The average score is 0%

0%